Matching criteria - Level

 

One of possible criteria is

 

o         All member belonging to selected level

 

We will colorize members from level Product Family  (Drink, Food, Non-Consumable) to yellow and then we

will drill all members from level Product Family to level Product Department with retaining parents. This way

we will have members from different levels on the table.

 

Rule:      Level of selected member will be taken as condition.

 

To start colorizing:

 

·            select button Extended table settings on tab Table

 

 

Dialog will appear:

 

 

·            select tab Row colors or Column colors (we will select Row colors)

 

 

·            select button Add to add members to be colorized

 

Dialog that contains all member grouped by hierarchies will appear:

 

 

Now make your choice:

 

·            uncheck Row Members box to deselect all

·            select Drink and Food

·            select OK

 

 

Now you are returned to previous dialog.

Selected Members are added to the table.

 

To add colors:

 

·            click on the cell for Fore color or Back color (our case Back color for Non-Consumable)

·            click on the button that appears inside cell

 

 

·            select color

·            select OK

 

 

Selection will appear inside table:

 

 

·            select  With condition cell to get menu

·            select one of the options from menu (we will select 5 – Level Unique Name)

 

 

After selection there is no need to add any condition to cell Condition string.

Level of member Drink will be taken as condition.

 

·            select OK

 

 

 

As you can entire table is yellow since Drink, Food and Non-Consumable belongs to same level.

Now:

 

·            double click over any member from Product.hProduct hierarchy

 

 

·            select DD Level (+)

it will drill and RETAIN parents on the table